Hệ thống quản lý trường học bằng PHP / MySQLi
1
2 <?php
3 error_reporting(0);//turning off error reporting
4 include("connect.php");
5 ?>
6 <?php
7 SESSION_START();
8 ?>
9
10 <?php
11
12 function get_all_records(){
13 include('connect.php');
14 $Sql = "SELECT * FROM studentstable";
15 $result = mysqli_query($db, $Sql);
16
17
18 if (mysqli_num_rows($result) > 0) {
19 echo "<div class='table-responsive'><table id='myTable' class='table table-striped table-bordered'>
20 <thead><tr> <th>Admission No.</th>
21 <th>Sirname</th>
22 <th>Firstname</th>
23 <th>Lastname</th>
24 <th>ID#</th>
25 <th>DOB</th>
26 <th>Gender</th>
27 <th>Country ID</th>
28 <th>County ID</th>
29 <th>Constituency ID</th>
30 <th>Mobile</th>
31 <th>Email</th>
32 <th>Address</th>
33 <th>Zip code</th>
34 <th>Course ID</th>
35 <th>Fee Balance</th>
36 </tr></thead><tbody>";
37
38
39
40 while($row = mysqli_fetch_assoc($result)) {
41
42 echo "<tr><td>" . $row['admission_number']."</td>
43 <td>" . $row['sirname']."</td>
44 <td>" . $row['firstname']."</td>
45 <td>" . $row['lastname']."</td>
46 <td>" . $row['idno']."</td>
47 <td>" . $row['dateofbirth']."</td>
48 <td>" . $row['gender']."</td>
49 <td>" . $row['country_id']."</td>
50 <td>" . $row['county_id']."</td>
51 <td>" . $row['constituency_id']."</td>
52 <td>" . $row['mobile']."</td>
53 <td>" . $row['email']."</td>
54 <td>" . $row['address']."</td>
55 <td>" . $row['zipcode']."</td>
56 <td>" . $row['course_id']."</td>
57 <td>" . $row['feepayable']."</td></tr>";
58 }
59
60 echo "</tbody></table></div>";
61
62 } else {
63 echo "you have no records";
64 }
65 }
66 ?>
67
68 <!DOCTYPE html>
69 <html lang="en">
70
71 <head>
72 <meta charset="utf-8">
73 <meta name="viewport" content="width=device-width, initial-scale=1.0">
74 <title>school management system</title>
75 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
76 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
77 <link href="assets/css/loader.css" rel="stylesheet" />
78 <script src="assets/js/canvasjs.min.js"></script>
79 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
80 <script src="assets/js/jquery-3.2.1.js"></script>
81 </head>
82
83 <body>
84 <!--end of heading section-->
85 <ul class="nav navbar-right top-nav">
86 <div class="dropdown">
87 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
88 <?php
89 //Check to see if the user is logged in.if not redirect user to the loging page.
90
91 if(isset($_SESSION['fname']))
92 {
93 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
94 }else{
95 echo "<script type='text/javascript'>
96 alert( 'You must Log in to use the system');
97 </script>";
98 echo "<script>
99 window.location = 'index.php'
100 </script>";
101 }
102 ?>
103 <span class="caret"></span></button>
104 <ul class="dropdown-menu">
105 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
106 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
107 <li class="divider"></li>
108 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
109 </ul>
110 </div>
111 </ul>
112 <!--************************************************-->
113
114 <div style="
115 font-family:Nyala, Arial;
116 text-align: left;
117 background-color: #526F35;
118 padding: 20px;
119 color:white;
120 width: 100%;
121 height: 150px;">
122 <!--This codes to load the image loader-->
123 <div id="loading">
124 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
125 </div>
126 <!--this is the heading section-->
127 <h2>
128 <?php
129 $sql="SELECT * FROM companyinfo";
130 $result=mysqli_query($db,$sql) or die("error getting data");
131 $num_rows=mysqli_num_rows($result);
132 while($row=mysqli_fetch_array($result))
133 {
134 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
135 $cname = $row['cname'];
136 $cemail = $row['cemail'];
137 $ccontact = $row['ccontact'];
138 $clocation = $row['clocation'];
139 }?>
140 <?php
141 echo $cname;
142 ?>
143
144 <div style="float:right; font-size:20px;text-align:right;">
145
146 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
147 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
148 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
149
150 </div>
151 </h2>
152 </div>
153 <!--end of heading section-->
154 <div>
155 <ul class="nav nav-tabs">
156 <li ><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
157 <li class="active"><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
158 <li ><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
159 <li ><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
160 <li ><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
161 <li><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
162 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
163 <li><a href="sms.php">SMS <img src="assets/img/details.png"></a></li>
164 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
165 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
166
167 </ul>
168 <div class="tab-content">
169 <div class="tab-pane active" role="tabpanel" id="tab-1">
170
171 <p>
172 <div class="table-responsive" >
173 <!--******************************Second tab section**********************************************-->
174 <div class="container" style="width:100%">
175
176 <ul class="nav nav-tabs">
177 <li ><a href="students.php">New Student <img src="assets/img/new.png"> </a></li>
178 <li><a href="viewstudentrecord.php">View List<img src="assets/img/view2.png"></a></li>
179 <li><a href="viewstudentsedit1.php">Edit Student<img src="assets/img/view2.png"></a></li>
180 <li class="active"><a href="csvstudents.php">Import/Export Data <img src="assets/img/import.png"></a></li>
181 <li><a href="reports_students.php">Reports </a></li>
182 </ul>
183 <br>
184
185 </div>
186
187 <!--*************************************************************************************************************************-->
188 <div id="wrap">
189 <div class="container">
190 <div class="row">
191
192 <form class="form-horizontal" action="studentsfunctions.php" method="post" name="upload_excel" enctype="multipart/form-data">
193
194
195 <fieldset>
196
197 <!-- File Button -->
198 <div class="form-group">
199 <label class="col-md-4 control-label" for="filebutton">Select File.</label>
200 <div class="col-md-4">
201 <input type="file" name="file" id="file" class="input-large">
202 </div>
203 </div>
204
205 <!-- Button -->
206 <div class="form-group">
207 <label class="col-md-4 control-label" for="singlebutton">Import data</label>
208 <div class="col-md-4">
209 <button type="submit" id="submit" name="Importstudent" class="btn btn-primary button-loading" data-loading-text="Loading...">Import</button>
210 </div>
211 </div>
212
213 </fieldset>
214 </form>
215
216 </div>
217 <!--function to display all the available records-->
218 <?php
219 get_all_records();
220 ?>
221 </div>
222 </div>
223 <!--exporting data******************************************-->
224
225 <div>
226 <form class="form-horizontal" action="studentsfunctions.php" method="post" name="upload_excel"
227 enctype="multipart/form-data">
228 <div class="form-group">
229 <div class="col-md-4 col-md-offset-4">
230 <input type="submit" name="Exportstudent" class="btn btn-success" value="Export to excel"/>
231
232
233 </div>
234 </div>
235 </form>
236 </div>
237 <script src="assets/js/jquery.min.js"></script>
238 <script src="assets/bootstrap/js/bootstrap.min.js"></script>
239 <script src="assets/js/affix.js"></script>
240 <script src="assets/js/alert.js"></script>
241 <script src="assets/js/alert1.js"></script>
242 <script src="assets/js/bootstrap.js"></script>
243 <script src="assets/js/bootstrap.min.js"></script>
244 <script src="assets/js/bootstrap-datepicker.js"></script>
245 <script src="assets/js/bootstrap-wysihtml5.js"></script>
246 <script src="assets/js/button.js"></script>
247 <script src="assets/js/carousel.js"></script>
248 <script src="assets/js/chosen.jquery.min.js"></script>
249 <script src="assets/js/ckeditor.js"></script>
250 <script src="assets/js/collapse.js"></script>
251 <script src="assets/js/color.js"></script>
252 <script src="assets/js/dropdown.js"></script>
253 <script src="assets/js/DT_bootstrap.js"></script>
254 <script src="assets/js/dynamic.js"></script>
255 <script src="assets/js/ie-emulation-modes-warning.js"></script>
256 <script src="assets/js/jquery.dataTables.js"></script>
257 <script src="assets/js/jquery.dataTables.min.js"></script>
258 <script src="assets/js/jquery.dialog.js"></script>
259 <script src="assets/js/jquery.hoverdir.js"></script>
260 <script src="assets/js/jquery.jgrowl.js"></script>
261 <script src="assets/js/jquery.knob.js"></script>
262 <script src="assets/js/jquery.uniform.min.js"></script>
263 <script src="assets/js/jquery-1.8.3.min.js"></script>
264 <script src="assets/js/jquery-1.9.1.js"></script>
265 <script src="assets/js/jquery-1.9.1.min.js"></script>
266 <script src="assets/js/jquery-1.10.2.js"></script>
267 <script src="assets/js/jquery-1.11.0.js"></script>
268 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
269 <script src="assets/js/jquery-ui-1.10.3.js"></script>
270 <script src="assets/js/modal.js"></script>
271 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
272 <script src="assets/js/myjquery.js"></script>
273 <script src="assets/js/myjquery1.js"></script>
274 <script src="assets/js/npm.js"></script>
275 <script src="assets/js/popover.js"></script>
276 <script src="assets/js/profile.js"></script>
277 <script src="assets/js/raphael-min.js"></script>
278 <script src="assets/js/sb-admin-2.js"></script>
279 <script src="assets/js/scripts.js"></script>
280 <script src="assets/js/scrollspy.js"></script>
281 <script src="assets/js/tab.js"></script>
282 <script src="assets/js/tooltip.js"></script>
283 <script src="assets/js/transition.js"></script>
284 <script src="assets/js/wysihtml5-0.3.0.js"></script>
285 <script language="javascript" type="text/javascript">
286 $(window).load(function()
287 {
288 $('#loading').hide();
289 });
290 </script>
291 </body>
292
293 </html>